UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cIYhMEUe7x3DqjGhySSWe7Zgfdo4Tqqsrgd7wI6gIss='
WHERE
key_id = 'e29f37c9d956f735217529d534d529ad190a75d7243f3302cb6041826feba9c6'
AND (
token = 'cIYhMEUe7x3DqjGhySSWe7Zgfdo4Tqqsrgd7wI6gIss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)