UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BixbTEo2bLKNZyRxfb1syJcZ8HPh/RCAYE/MK7izYWk='
WHERE
key_id = 'd27b83d2b71b55ebca03e6835311d5e96e9533b0236189781c780989f17e965c'
AND (
token = 'BixbTEo2bLKNZyRxfb1syJcZ8HPh/RCAYE/MK7izYWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)