UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kiR2WlZqRf2IRjPUqEPLz0NR0I5dkuKg8lDuONUF4po='
WHERE
key_id = '7e164050eb1ad4529152c8620b96973a0b1dc9239b26b411268439e3145da124'
AND (
token = 'kiR2WlZqRf2IRjPUqEPLz0NR0I5dkuKg8lDuONUF4po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)