UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6MnsAOgyVUKJivUW9lrK7BlFWpj+Hku7fA/laW1JVE8='
WHERE
key_id = '5afee917ee5e125eb5074319011da94bdbb25f4669b75e6ce5c15d1a51d7cfdb'
AND (
token = '6MnsAOgyVUKJivUW9lrK7BlFWpj+Hku7fA/laW1JVE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)