UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Thca26y0djSaSdwu5sluwdzwi51nUjPdlYVkhlc9cQ='
WHERE
key_id = 'f0ca62a4b47f455fd39afc243f59735f11882a76f73d5358601c8fdf2da49414'
AND (
token = '6Thca26y0djSaSdwu5sluwdzwi51nUjPdlYVkhlc9cQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)