UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lXo8nTwLgrIPUqDBGx3k2rqTBl9c1l98zVVK4jiATRI='
WHERE
key_id = 'd7a0e6616a8e631442afc2fff6d7fbca4b0ec1c487044f72b5526190264c77c5'
AND (
token = 'lXo8nTwLgrIPUqDBGx3k2rqTBl9c1l98zVVK4jiATRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)