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