UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AHe+gHGdtfQOt1u4nu5o5qdzxuYR/DfbC9kCxGsogoM='
WHERE
key_id = 'd7412687239cd1378ae2be68814167ff963f307e96c97aea7b85846c8debe258'
AND (
token = 'AHe+gHGdtfQOt1u4nu5o5qdzxuYR/DfbC9kCxGsogoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)