UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZytN1DiNWd4liQ6LulGCkfZ5AFsiLN3iIGy6xG2d+s4='
WHERE
key_id = '47779243b550e4ce50a8e2de3c4788c044742cc0d07079060afd538aaa45d34a'
AND (
token = 'ZytN1DiNWd4liQ6LulGCkfZ5AFsiLN3iIGy6xG2d+s4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)