UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n6S2Xolp19BZ5bOpCKQlLv3cicTXgWldyEl7w/YS9Dk='
WHERE
key_id = '27b54d20b06a423c698217d939cc6c9907891202c6134e86bdf8e2b434850b6f'
AND (
token = 'n6S2Xolp19BZ5bOpCKQlLv3cicTXgWldyEl7w/YS9Dk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)