UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S5mXgBhnvlKnWFoyJANXCiZRzSFuUbWjwrHRoJGK25c='
WHERE
key_id = '9efc80e144438620acd1fe3ecb6fc2d94844728c97f78447028ec0108d1b3037'
AND (
token = 'S5mXgBhnvlKnWFoyJANXCiZRzSFuUbWjwrHRoJGK25c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)