UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Qnlopxf45RRfSZ2lWSTgeizlOBEY8VbTYYdw+kZ4/s='
WHERE
key_id = '09af221dcad47e2c9e26c92579ec2a77dc5f631b707f387175726e7a43b94d8a'
AND (
token = '9Qnlopxf45RRfSZ2lWSTgeizlOBEY8VbTYYdw+kZ4/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)