UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'opCA4NYpDyT7xULydkqy4fHDgsygOa901jElZRd/xXo='
WHERE
key_id = '9339a9723cf7e859594c0d22d0a658ac05856988729008407fcc3ee6cc7ef2bd'
AND (
token = 'opCA4NYpDyT7xULydkqy4fHDgsygOa901jElZRd/xXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)