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