UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4pQKdR3+Opyxc0F/4M8cedkhhUJQSRVpUSoCeV0QiJ0='
WHERE
key_id = '9f869ae2a86ccfed374ad8afb0d55f35b89078f6a5a437cbfb3d8d0bd41acf37'
AND (
token = '4pQKdR3+Opyxc0F/4M8cedkhhUJQSRVpUSoCeV0QiJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)