UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OSGp11wHUP4tp2AEOW/HCpS1BOxLiPW3A27NKJW8J0c='
WHERE
key_id = 'e872b612d9a568a485b4a0e4105e0d2fdea72a96594c70a1dcefcd40f098ca60'
AND (
token = 'OSGp11wHUP4tp2AEOW/HCpS1BOxLiPW3A27NKJW8J0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)