UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Xh26Hot2FIKbnU86z8I7xcXSw18ucBnOiiuLZvCGTQ='
WHERE
key_id = 'f86ab013630236a234d03d2f25446166a3bdcc5bd1a74fd8668231d08f855e87'
AND (
token = '8Xh26Hot2FIKbnU86z8I7xcXSw18ucBnOiiuLZvCGTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)