UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BY8AdANjQE3AbrtTevl5P2otIYU3Le/5E4bTetfSv+c='
WHERE
key_id = '3786927b3abee3d95cbbc527f3016d59e437121d732ae145f941b32fd25dd6a5'
AND (
token = 'BY8AdANjQE3AbrtTevl5P2otIYU3Le/5E4bTetfSv+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)