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