UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBewt4NYKaV8/lSLUL2YgW9sGwRA9y/OFUEm1EOf2FI='
WHERE
key_id = 'c255811c9f1776b0bc47eb4b83acdc4a7d84bf90d337a50251a0cf93c43a5194'
AND (
token = 'pBewt4NYKaV8/lSLUL2YgW9sGwRA9y/OFUEm1EOf2FI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)