UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g7Oam+984HINJ0+dc3yevF9GkxsvZ9DNcVkG1eyHnAc='
WHERE
key_id = 'c5a266115c10c2530648d2b7c3ecc6d3f443194cd7b794ecb0f7cf4bcee535f0'
AND (
token = 'g7Oam+984HINJ0+dc3yevF9GkxsvZ9DNcVkG1eyHnAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)