UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXmhQqWm0YEC6SX4DDJHv03tCvXe8Iz+qSDZoAK8aY4='
WHERE
key_id = 'dacf2abbffb64559479f357fb83f1b12912a7e3dc3cbb7168afed6402a6bfb73'
AND (
token = 'BXmhQqWm0YEC6SX4DDJHv03tCvXe8Iz+qSDZoAK8aY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)