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