UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cY7AaYVYvmKyIN27ksayh+56WxCg6A8dDjNbWiEVYOs='
WHERE
key_id = '0309cbf5be2038f70e47ea9b2aefeabeb7307f6b2e1a01b187e908e134afaeab'
AND (
token = 'cY7AaYVYvmKyIN27ksayh+56WxCg6A8dDjNbWiEVYOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)