UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cUzqwYn5Tv429W0pALmhyYgIrTw5W2hHM5xMjVbwel8='
WHERE
key_id = '27dab65bfa6f17364d44de4f30b16d708271dfdef1e144241d2e7836dc3b11b0'
AND (
token = 'cUzqwYn5Tv429W0pALmhyYgIrTw5W2hHM5xMjVbwel8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)