UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L0LI0NWE4ywf1Umh0xy1UVZsfZxednk8y42wY4pDVSQ='
WHERE
key_id = '365cf0fe119a84c442210fc199d28e3e55e9ace005867b727cb32be9059ab573'
AND (
token = 'L0LI0NWE4ywf1Umh0xy1UVZsfZxednk8y42wY4pDVSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)