UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WcKkZHXEv2nLHX8BqcIAKqHCtqSpyiqv1jS1NS78DpA='
WHERE
key_id = '4d93def48040ed2a71e525c99b1eed629440bb084f2b7cc1abc3180b166efbdf'
AND (
token = 'WcKkZHXEv2nLHX8BqcIAKqHCtqSpyiqv1jS1NS78DpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)