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