UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9n4gW7j8VSxHhen+woIEZypLHt1W9MIZAJvFAPJTi+8='
WHERE
key_id = '92e5d53d49ea034bf716c3aaee3c5d1ebccc53e3ac19237fb85fb7bf65c77c27'
AND (
token = '9n4gW7j8VSxHhen+woIEZypLHt1W9MIZAJvFAPJTi+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)