UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mwa7C+jtOMP4xKY4uXgI7Yz50bS1wHmv4bZxqjAl1Uc='
WHERE
key_id = '078691686ccef5ff12d665e555d97ec38f6a27e28c462dfa65490cb12b3c996a'
AND (
token = 'mwa7C+jtOMP4xKY4uXgI7Yz50bS1wHmv4bZxqjAl1Uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)