UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rODTi/XSZRBNz+a5GMsv9u2Do7iX4XFAYIKtzS+JVM='
WHERE
key_id = '86217a9fd53dcd9878527648fc6d4743d94506ff1fa7c277ad00448f8e87b658'
AND (
token = '8rODTi/XSZRBNz+a5GMsv9u2Do7iX4XFAYIKtzS+JVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)