UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h/3mRmF7n9MUiZAqGT4drLfBKjZD30DYLOkJFh8an1k='
WHERE
key_id = '786d30436050d8f3270020ce678654669b63b2b24f49721a83941a2b2c35c7ad'
AND (
token = 'h/3mRmF7n9MUiZAqGT4drLfBKjZD30DYLOkJFh8an1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)