UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e8EvlBIJhjRPy0MLQDrBzdyzHYjPuqX3qxVHmlauhvQ='
WHERE
key_id = '59b63ecb46df80e228c8c01a603e23aa66a63820e071266ee9bc59ed9faafbc1'
AND (
token = 'e8EvlBIJhjRPy0MLQDrBzdyzHYjPuqX3qxVHmlauhvQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)