UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IrHgjwEe5zStz5r7DV5YnDxncSP+uVwEyNzJvANeg5U='
WHERE
key_id = '12c814bc489283230a9fae9729eb5cb36f7db504057a623ae88489f49c3b6512'
AND (
token = 'IrHgjwEe5zStz5r7DV5YnDxncSP+uVwEyNzJvANeg5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)